|
Note: This function is only provided with the MS SQL server interface add-on (Enabling or disabling add-ons). |
1. In the File menu, select the Export > Database entry.
The Select database window opens.
2. Select MS SQL server.
3. Confirm with OK.
The Data link properties window opens.
4. Select the Provider tab.
5. Select the appropriate provider for SQL servers, for example Microsoft OLE DB provider for SQL server.
6. Select the Connection tab.
|
Tip: Alternatively you can click the Next button in the Provider tab. |
7. Enter the server name where the SQL database is.
|
Tip: Alternatively select the name from the drop-down list. |
8. Enter user name and password to access the SQL server.
9. Select the option Allow password to be saved.
10. From the drop-down list select the desired database on the SQL server.
|
Tip: You can check whether the connection to the SQL server has been established and export to the database can take place by clicking the Test connection button. |
11. Confirm with OK.
The Save network (user-defined) window opens.
12. Make the desired settings (Saving a network file).
13. Confirm with OK.
A query opens.
14. Confirm with Yes.
The selected network tables and attributes are exported to the database on the SQL server.
